| # | Cash flow per Share | ((IB+DP)/CSHO) | (Income Bef. Extra. Items+Depreciation)/Common Shares Outstanding | 4 | 1 | 1
|
|---|
| 1 | Current Ratio | (ACT/LCT) | Current Assets/Current Liabilities | 1 | 1 | 1 |
| 2 | Quick Ratio | ((CHE+RECT)/LCT) | (Cash && Equivalents+Total Receivables)/Current Liabilities | 1 | 1 | 1 |
| 3 | Working Capital per Share | ((ACT-LCT)/CSHO) | (Current Assets-Current Liabilities)/Common Shares Outstanding | 4 | 1 | 1 |
| 4 | Average Collection Period (Days) | (@PAVG(RECT,-1,0)/(SALE/365)) | Total Receivables/(Sales (Net) 12 Month Moving Avg./365) | 1 | 1 | 2 |
| 5 | Days to Sell Inventory | (@PAVG(INVT,-1,0)/(COGS/365)) | Total Inventory/(Cost of Goods Sold 12 Mo. Moving Avg./365) | 1 | 1 | 2 |
| 6 | Inventory Turnover | (COGS/@PAVG(INVT,-1,0)) | Cost of Goods Sold/Avg. Inventory | 1 | 1 | 2 |
| 7 | Operating Cycle (Days) | ((@PAVG(RECT,-1,0)/(SALE/365))+(@PAVG(INVT,-1,0)/(COGS/365))) | Avg. Receivables/(Sales/365)+Avg. Inventory/COGS | 1 | 1 | 2 |
| 8 | Receivables Turnover | (SALE/@PAVG(RECT,-1,0)) | Sales/Avg. Receivables | 1 | 1 | 2 |
| 9 | Total Assets Turnover | (SALE/@PAVG(AT,-1,0)) | Sales/Total Assets | 1 | 1 | 2 |
| 10 | Sale/PP&E | (SALE/PPENT) | Sale/PP&&E | 1 | 1 | 3 |
| 11 | Sales/Shareholder Equity | (SALE/SEQ) | Sales/Shareholder Equity | 1 | 1 | 3 |
| 12 | EBIT Margin | ((SALE-COGS-@VALUE(XSGA,0)-@VALUE(DP,0))/SALE) | Operating Profit | 2 | 1 | 4 |
| 13 | EBITDA Margin | ((SALE-COGS-@VALUE(XSGA,0))/SALE) | Operating Profit Before Depreciation | 2 | 1 | 4 |
| 14 | Gross Margin | ((SALE-COGS)/SALE) | (Sales-Cost of Goods Sold)/Sales | 2 | 1 | 4 |
| 15 | Net Margin | (IB/SALE) | Income Before Extra. Items/Sales | 2 | 1 | 4 |
| 16 | Pretax Margin | (PI/SALE) | Pretax Income/Sales | 2 | 1 | 4 |
| 17 | Return on Assets | (IB/AT) | Income Before Ext. Items/Total Assets | 2 | 1 | 5 |
| 18 | Return on Average Assets | (IB/@PAVG(AT,-1,0)) | Income Before Ext. Items/Avg. Assets | 2 | 1 | 5 |
| 19 | Return on Average Equity | (IB/@PAVG(CEQ,-1,0)) | Income Before Ext. Items/Avg. Common Equity | 2 | 1 | 5 |
| 20 | Return on Average Investment | (IB/@PAVG(ICAPT,-1,0)) | Income Before Ext. Items/Avg. Invested Capital | 2 | 1 | 5 |
| 21 | Return on Equity | (IB/CEQ) | Income Before Ext. Items/Common Equity | 2 | 1 | 5 |
| 22 | Return on Investment | (IB/ICAPT) | Income Before Ext. Items/Invested Capital | 2 | 1 | 5 |
| 23 | Net Interest Coverage | ((IB+XINT)/XINT) | (Income Bef. Extra. Items+Interest Expense)/Interest Expense | 1 | 1 | 6 |
| 24 | Pretax Interest Coverage | ((PI+XINT)/XINT) | (Pretax Income+Int. Expense)/Int. Expense | 1 | 1 | 6 |
| 25 | Total Assets to Common Equity | (AT/CEQ) | Total Assets/Common Equity | 1 | 1 | 6 |
| 26 | Total Debt to Common Equity | (DT/CEQ) | Total Debt/Common Equity | 2 | 1 | 6 |
| 27 | Total Debt to Invested Capital | ((DT+DLC)/ICAPT) | Total Debt/Invested Capital | 2 | 1 | 6 |
| 28 | Total Debt to Total Assets | ((DT+DLC)/AT) | Total Debt/Total Assets | 2 | 1 | 6 |
| 29 | Total Debt to Total Equity | (DT/(CEQ+PSTK)) | Total Debt/Total Equity | 2 | 1 | 6 |
| 30 | Div/Share Exdate | (DVPSX) | Div/Share Exdate | 4 | 1 | 7 |
| 31 | Dividend Payout Ratio | (DVC/IBADJ) | Cash Dividends/Income Before Extra. Items Adjusted for Common Equiv. | 2 | 1 | 7 |
| 32 | Dividend Yield - Fiscal Year End | (DVYDF/100) | Current Annual Div. Rate/Fiscal Year Close Price | 2 | 1 | 7 |
| 33 | Market to Book-Fiscal Year End | ((PRCCF*CSHO)/CEQ) | (Fiscal Year Close Price*Common Shares Outstanding)/Common Equity | 1 | 1 | 7 |
| 34 | Market Value-Fiscal Year End | (PRCCF*CSHO) | Fiscal Year Close Price*Common Shares Outstanding | 3 | 1 | 7 |
| 35 | Price High-Low-Close-Volume | | Price High-Low-Close-Volume | 9 | 1 | 7 |
| 36 | Price/Earnings Ratio | (PRCCF/EPSPX) | Fiscal Year Close Price/12 Mo. Avg. Earnings per Share | 1 | 1 | 7 |
| 37 | Common Equity | (CEQ) | Common Equity | 3 | 1 | 8 |
| 38 | Common Shares Outstanding | (CSHO) | Common Shares Outstanding | 5 | 1 | 8 |
| 39 | Total Assets | (AT) | Total Assets | 3 | 1 | 8 |
| 40 | Total Current Assets | (ACT) | Total Current Assets | 3 | 1 | 8 |
| 41 | Total Current Liabilities | (LCT) | Total Current Liabilities | 3 | 1 | 8 |
| 42 | Total Liabilities | (LT) | Total Liabilities | 3 | 1 | 8 |
| 43 | Adjusted Net Income | (NIADJ) | Adjusted Net Income | 3 | 1 | 9 |
| 44 | Dividends Per Share | (DVPSX) | Dividends Per Share | 4 | 1 | 9 |
| 45 | Earnings Per Share-Fully Diluted | (EPSFI) | Earnings Per Share-Fully Diluted | 4 | 1 | 9 |
| 46 | Gross Profit | (SALE-COGS) | Gross Profit | 3 | 1 | 9 |
| 47 | Operating Profit | (OIADP) | Operating Profit | 3 | 1 | 9 |
| 48 | Pretax Income | (PI) | Pretax Income | 3 | 1 | 9 |
| 49 | Sales | (SALE) | Sales | 3 | 1 | 9 |
| 50 | Cash & Equivalents-Change | (CHECH) | Cash && Equivalents-Change | 3 | 1 | 10 |
| 51 | Financing Activities-Net Cash Flow | (FINCF) | Financing Activities-Net Cash Flow | 3 | 1 | 10 |
| 52 | Investing Activities-Net Cash Flow | (IVNCF) | Investing Activities-Net Cash Flow | 3 | 1 | 10 |
| 53 | Operating Activities-Net Cash Flow | (OANCF) | Operating Activities-Net Cash Flow | 3 | 1 | 10 |
| 54 | Cash flow per Share | (CFLQ/CSHOQ) | (Income Bef. Extra. Items+Depreciation)/Common Shares Outstanding | 4 | 2 | 1 |
| 55 | Current Ratio | (ACTQ/LCTQ) | Current Assets/Current Liabilities | 1 | 2 | 1 |
| 56 | Quick Ratio | ((CHEQ+RECTQ)/LCTQ) | (Cash && Equivalents+Total Receivables)/Current Liabilities | 1 | 2 | 1 |
| 57 | Working Capital per Share | ((ACTQ-LCTQ)/CSHOQ) | (Current Assets-Current Liabilities)/Common Shares Outstanding | 4 | 2 | 1 |
| 58 | Average Collection Period (Days) | (@PAVG(RECTQ,-3,0)/(SALE12/365)) | Total Receivables/(Sales (Net) 12 Month Moving Avg./365) | 1 | 2 | 2 |
| 59 | Days to Sell Inventory | (@PAVG(INVTQ,-3,0)/(COGS12/365)) | Total Inventory/(Cost of Goods Sold 12 Mo. Moving Avg./365) | 1 | 2 | 2 |
| 60 | Inventory Turnover | (COGS12/@PAVG(INVTQ,-3,0)) | Cost of Goods Sold 12 Mo. Moving/Avg. Inventory | 1 | 2 | 2 |
| 61 | Operating Cycle (Days) | ((@PAVG(RECTQ,-3,0)/(SALE12/365))+(@PAVG(INVTQ,-3,0)/(COGS12/365))) | Avg. Receivables/(Sales/365)+Avg. Inventory/COGS | 1 | 2 | 2 |
| 62 | Receivables Turnover | (SALE12/@PAVG(RECTQ,-3,0)) | Sales/Avg. Receivables | 1 | 2 | 2 |
| 63 | Total Assets Turnover | (SALE12/@PAVG(ATQ,-3,0)) | Sales/Total Assets | 1 | 2 | 2 |
| 64 | Sale/PP&E | (SALEQ/PPENTQ) | Sale/PP&&E | 1 | 2 | 3 |
| 65 | Sales/Shareholder Equity | (SALEQ/SEQQ) | Sales/Shareholder Equity | 1 | 2 | 3 |
| 66 | EBIT Margin | ((SALEQ-COGSQ-@VALUE(XSGAQ,0)-@VALUE(DPQ,0))/SALEQ) | Operating Profit | 2 | 2 | 4 |
| 67 | EBITDA Margin | ((SALEQ-COGSQ-@VALUE(XSGAQ,0))/SALEQ) | Operating Profit Before Depreciation | 2 | 2 | 4 |
| 68 | Gross Margin | ((SALEQ-COGSQ)/SALEQ) | (Sales-Cost of Goods Sold)/Sales | 2 | 2 | 4 |
| 69 | Net Margin | (IBQ/SALEQ) | Income Before Extra. Items/Sales | 2 | 2 | 4 |
| 70 | Pretax Margin | (PIQ/SALEQ) | Pretax Income/Sales | 2 | 2 | 4 |
| 71 | Return on Assets | (IB12/ATQ) | 12MM Income Before Ext. Items/Total Assets | 2 | 2 | 5 |
| 72 | Return on Average Assets | (IB12/@PAVG(ATQ,-3,0)) | 12MM Income Before Ext. Items/Avg. Assets | 2 | 2 | 5 |
| 73 | Return on Average Equity | (IB12/@PAVG(CEQQ,-3,0)) | 12MM Income Before Ext. Items/Avg. Common Equity | 2 | 2 | 5 |
| 74 | Return on Average Investment | (IB12/@PAVG(ICAPTQ,-3,0)) | 12MM Income Before Ext. Items/Avg. Invested Capital | 2 | 2 | 5 |
| 75 | Return on Equity | (IB12/CEQQ) | 12MM Income Before Ext. Items/Common Equity | 2 | 2 | 5 |
| 76 | Return on Investment | (IB12/ICAPTQ) | 12MM Income Before Ext. Items/Invested Capital | 2 | 2 | 5 |
| 77 | Net Interest Coverage | (ICQ) | (Income Bef. Extra. Items+Interest Expense)/Interest Expense | 1 | 2 | 6 |
| 78 | Pretax Interest Coverage | (ICBTQ) | (Pretax Income+Int. Expense)/Int. Expense | 1 | 2 | 6 |
| 79 | Total Assets to Common Equity | (ATQ/CEQQ) | Total Assets/Common Equity | 1 | 2 | 6 |
| 80 | Total Debt to Common Equity | (@VALUE(DTQ/CEQQ,(DTQ/CEQQ)[-1])) | Total Debt/Common Equity | 2 | 2 | 6 |
| 81 | Total Debt to Invested Capital | (DTQ/ICAPTQ) | Total Debt/Invested Capital | 2 | 2 | 6 |
| 82 | Total Debt to Total Assets | (DTQ/ATQ) | Total Debt/Total Assets | 2 | 2 | 6 |
| 83 | Total Debt to Total Equity | (DTEQQ/100) | Total Debt/Total Equity | 2 | 2 | 6 |
| 84 | Div/Share Exdate | (DVPSXQ) | Div/Share Exdate | 4 | 2 | 7 |
| 85 | Common Equity | (CEQQ) | Common Equity | 3 | 2 | 8 |
| 86 | Common Shares Outstanding | (CSHOQ) | Common Shares Outstanding | 5 | 2 | 8 |
| 87 | Total Assets | (ATQ) | Total Assets | 3 | 2 | 8 |
| 88 | Total Current Assets | (ACTQ) | Total Current Assets | 3 | 2 | 8 |
| 89 | Total Current Liabilities | (LCTQ) | Total Current Liabilities | 3 | 2 | 8 |
| 90 | Total Liabilities | (LTQ) | Total Liabilities | 3 | 2 | 8 |
| 91 | Adjusted Net Income | (NIQ-DVPQ+CSTKEQ) | Adjusted Net Income | 3 | 2 | 9 |
| 92 | Dividends Per Share | (DVPSXQ) | Dividends Per Share | 4 | 2 | 9 |
| 93 | Earnings Per Share-Fully Diluted | (EPSFIQ) | Earnings Per Share-Fully Diluted | 4 | 2 | 9 |
| 94 | Gross Profit | (SALEQ-COGSQ) | Gross Profit | 3 | 2 | 9 |
| 95 | Operating Profit | (OIADPQ) | Operating Profit | 3 | 2 | 9 |
| 96 | Pretax Income | (PIQ) | Pretax Income | 3 | 2 | 9 |
| 97 | Sales | (SALEQ) | Sales | 3 | 2 | 9 |
| 98 | Cash & Equivalents-Change | (CHECHQ) | Cash && Equivalents-Change | 3 | 2 | 10 |
| 99 | Financing Activities-Net Cash Flow | (FINCFQ) | Financing Activities-Net Cash Flow | 3 | 2 | 10 |
| 100 | Investing Activities-Net Cash Flow | (IVNCFQ) | Investing Activities-Net Cash Flow | 3 | 2 | 10 |
| 101 | Operating Activities-Net Cash Flow | (OANCFQ) | Operating Activities-Net Cash Flow | 3 | 2 | 10 |
| 102 | Dividend Yield | (DVIQ[@QTR(-2M)]/PRCCM) | Current Annual Div. Rate/Current Monthly Close Price | 2 | 3 | 7 |
| 103 | Indexed Price Performance | PRCCM | Close Price/Beg. Period Close Price-1 | 2 | 3 | 7 |
| 104 | Market to Book | (MKVALM/@VALUE(CEQQ[@QTR(-2M)],@VALUE(CEQQ[@QTR(-2M)-1],CEQQ[@QTR(-2M)-2]))) | Market to Book | 1 | 3 | 7 |
| 105 | Market Value | MKVALM | Market Value | 3 | 3 | 7 |
| 106 | Price High-Low-Close-Volume | | Price High-Low-Close-Volume | 9 | 3 | 7 |
| 107 | Price/Earnings Ratio | PEM | Monthly Close Price/Earnings per Share | 1 | 3 | 7 |
| 108 | Indexed Price Performance | PRCCD | Daily Close Price/Beg. Period Daily Close Price-1 | 2 | 4 | 7 |
| 109 | Market Value | (MKVALD) | Market Value | 3 | 4 | 7 |
| 110 | Momentum | (PRCCD/PRCCD[-10])-1 | Daily Close Price/10 Days Prior Close Price | 1 | 4 | 7 |
| 111 | Percentage Change | (PRCCD/PRCCD[-1])-1 | Daily Close Price/Prev. Day Close Price | 2 | 4 | 7 |
| 112 | Price High-Low-Close-Volume | | Price High-Low-Close-Volume | 9 | 4 | 7 |
| 113 | Price/Earnings Ratio | (PRCCD/EPS) | Daily Close Price/Current Earnings per Share | 1 | 4 | 7
|
